package com.isoft.dailymanprovidor.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;


import com.isoft.dailymanprovidor.entity.MeetingRoom;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface MeetingRoomDao extends BaseMapper<MeetingRoom> {
    /*新增会议室信息维护*/
    @Insert("INSERT INTO TMIM_SYSTEM.TB_MEETING_ROOM(name,number,FACILITIES,LOCATION,CAPACITY,NOTES) VALUES(#{name},#{number},#{facilities},#{location},#{capacity},#{notes});")
    public int Addmeetingroom(MeetingRoom meetingRoom);

    //修改会议室状态
    @Update("update TMIM_SYSTEM.TB_MEETING_ROOM set status=#{status} where ID=#{id}")
    public int updatastatus(MeetingRoom meetingRoom);


}
